home *** CD-ROM | disk | FTP | other *** search
- <!--- Create Criteria string for query from data entered thru search form --->
- <CFSET Criteria = ''>
- <CF_dbdrilldown_AppendCriteria
- FieldName="#Form.Crit1_FieldName#"
- FieldType="#Form.Crit1_FieldType#"
- Operator="#Form.Crit1_Operator#"
- Value="#Form.Crit1_Value#">
- <CF_dbdrilldown_AppendCriteria
- FieldName="#Form.Crit2_FieldName#"
- FieldType="#Form.Crit2_FieldType#"
- Operator="#Form.Crit2_Operator#"
- Value="#Form.Crit2_Value#">
- <CF_dbdrilldown_AppendCriteria
- FieldName="#Form.Crit3_FieldName#"
- FieldType="#Form.Crit3_FieldType#"
- Operator="#Form.Crit3_Operator#"
- Value="#Form.Crit3_Value#">
-
-
- <!--- Query returning search results --->
- <CFQUERY name="SearchResult" dataSource="hotel">
- SELECT DISTINCT hotels.HotelName AS ResultField1, hotels.StarRating AS ResultField2, hotels.City AS ResultField3, hotels.HotelID AS ID_Field
- FROM hotels
- WHERE
- #PreserveSingleQuotes(Criteria)#
- </CFQUERY>
-
-
- <HTML><HEAD>
- <TITLE>db drilldown - Search Result</TITLE>
- </HEAD><BODY bgcolor="ffffff">
-
-
- <FONT size="+1">db drilldown</FONT> <BR>
- <FONT size="+2"><B>Search Result</B></FONT>
-
- <P>
-
- <TABLE border=0 cellpadding=3 cellspacing=0>
-
- <TR bgcolor="cccccc">
- <TD> </TD>
- <TD>HotelName</TD>
- <TD>StarRating</TD>
- <TD>City</TD>
-
- </TR>
-
- <CFOUTPUT query="SearchResult">
- <TR bgcolor="#IIf(CurrentRow Mod 2, DE('ffffff'), DE('ffffcf'))#">
- <TD><A href="dbdrilldown_Detail.cfm?ID=#URLEncodedFormat(ID_Field)#">[detail]</A></TD>
- <TD>#ResultField1#</TD>
- <TD>#ResultField2#</TD>
- <TD>#ResultField3#</TD>
-
- </TR>
- </CFOUTPUT>
-
- </TABLE>
-
-
- </BODY></HTML>
-